package Finance::Pershing::StandardFiles::Store::Result::SelectLink;

use strict;
use warnings;

use aliased 'Finance::Pershing::StandardFiles::Store::Result::SelectLink::Detail';

use base 'DBIx::Class';

__PACKAGE__->load_components(qw/Core/);
__PACKAGE__->table('households');
__PACKAGE__->add_columns(
  household_id => {
    data_type => "VARCHAR",
    is_nullable => 0,
    size => 9,
  },
  lead_acctnum => {
    data_type => "CHAR",
    is_nullable => 0,
    size => 9
  },
  ibd => {
    data_type => "VARCHAR",
    is_nullable => 0,
    size => 3
  },
  group_purpose => {
    data_type => "CHAR",
    is_nullable => 0,
    size => 1,
  },
  gets_summary_page  => {
    data_type => "TINYINT",
    is_nullable => 0,
    size => 1,
  },
  principal_interested_party_ind   => {
    data_type => "CHAR",
    is_nullable => 0,
    size => 1,
  }
);

__PACKAGE__->set_primary_key(qw/household_id/);

__PACKAGE__->has_many(
  detail => Detail,
  { 'foreign.household_id' => 'self.household_id' },
);


1;

